INDEX RANGE SCAN
Short Description
An INDEX RANGE SCAN retrieves a range of rowids from an index. It is the most common form of index access where equality is not specified.
Detailed Description​
The index range scan is one of the most common access methods. During an index range scan, Oracle accesses adjacent index entries and then uses the ROWID values in the index to retrieve the table rows.
Rows are returned in the sort order of the index. This can be an advantage if your required order matches this as an additional sort can be avoided, but remember that the order of the data is not guaranteed unless you specify it.
Further Reading​
- Oracle Magazine - How to read an execution plan
- Oracle Tuning Guide - Explaining and Displaying Execution Plans
- Oracle Tuning Guide - Comparing Execution Plans Tutorial
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.